﻿CREATE TABLE [org].[Employee] (
    [EmployeeId]          INT             NOT NULL,
    [EmployeeCode]        CHAR (3)        NOT NULL,
    [EmployeeName]        VARCHAR (50)    NOT NULL,
    [EmployeeDescription] NVARCHAR (1000) NULL,
    [EmployeeStartDate]   DATE            NOT NULL,
    [EmployeeEndDate]     DATE            NULL,
    [IsLatest]            BIT             NOT NULL,
    [IsActive]            BIT             NOT NULL,
    [IsInternal]          BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([EmployeeId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

